<style>
.BtnAttach{ width: 100% !important;
border: none!important;
background: url(/SiteAssets/Image/icon/attach.png)!important;
background-repeat: no-repeat !important;
height: 60px !important;}
#c_Control71 {
border: none !important;
outline:none !important;
}
.BtnAttach:hover{ width: 100% !important;
cursor:pointer;
background: url(/SiteAssets/Image/icon/attachClick.png)!important;
background-repeat: no-repeat !important;
border: none!important;}
#dg_Details_IntText_{
text-align: right;
}
.BtnReturn{ width: 100% !important;
border: none!important;
background: url(/SiteAssets/Image/icon/return.png)!important;
background-repeat: no-repeat !important;
height: 60px !important;}
#c_Control51{
border: none !important;
outline:none !important;
}
.BtnReturn:hover{ width: 100% !important;
cursor:pointer;
background: url(/SiteAssets/Image/icon/returnClick.png)!important;
background-repeat: no-repeat !important;
border: none!important;}
.BtnReturn2{ width: 100% !important;
border: none!important;
background: url(/SiteAssets/Image/icon/return2.png)!important;
background-repeat: no-repeat !important;
height: 35px !important;
width: 100px !important;}
#c_Control70{
border: none !important;
outline:none !important;
margin-right: 20px !important;
}
.BtnReturn2:hover{ width: 100% !important;
cursor:pointer;
background: url(/SiteAssets/Image/icon/returnClick2.png)!important;
background-repeat: no-repeat !important;
border: none!important;
height: 35px !important;
width: 100px !important;}
.BtnResend{ width: 100% !important;
border: none!important;
background: url(/SiteAssets/Image/icon/resend.png)!important;
background-repeat: no-repeat !important;
height: 60px !important;}
#c_Control22{
border: none !important;
outline:none !important;
}
.BtnResend:hover{ width: 100% !important;
cursor:pointer;
background: url(/SiteAssets/Image/icon/resendClick.png)!important;
background-repeat: no-repeat !important;
border: none!important;}
.BtnSubmit{ width: 100% !important;
border: none!important;
background: url(/SiteAssets/Image/icon/submit.png)!important;
background-repeat: no-repeat !important;
height: 60px !important;}
#c_Save{
border: none !important;
outline:none !important;
}
.BtnSubmit:hover{ width: 100% !important;
cursor:pointer;
background: url(/SiteAssets/Image/icon/submitClick.png)!important;
background-repeat: no-repeat !important;
border: none!important;}
.BtnExcel{ width: 100% !important;
border: none!important;
background: url(/SiteAssets/Image/icon/Excel.png)!important;
background-repeat: no-repeat !important;
height: 40px !important;}
#c_Control78 {
border: none !important;
outline:none !important;
margin-right: -1px !important;}
#c_Control79 {
border: none !important;
outline:none !important;
margin-right: -1px !important;}
.BtnExcel:hover{ width: 100% !important;
cursor:pointer;
background: url(/SiteAssets/Image/icon/ExcelClick.png)!important;
background-repeat: no-repeat !important;
border: none!important;}
.k-content td
{
padding-left:0px;
padding-right:0px
}
.k-content table
{
border: 0px;border-collapse: collapse;border-spacing: 0px;
}
.pf-main-form .k-button {
padding : 2px 5px ;
border-bottom :2px solid #DA742C
border-right :2px solid #DA742C;
border-radius: 10px;
color: black ;
font-family: vazir !important;}
.k-state-active, .k-state-active:hover, .k-active-filter{
border-color: #e69a4a;
}
input[style*="text-align: left"]{direction :ltr;}
textarea{border-radius: 4px !important;font-family: IRANSansWeb !important;}
.pf-section-header-text {float: right !important;}
input[style*="text-align: left"]{direction :ltr;}
td:not([align]) > div > textarea
{
direction : ltr;
text-align:right;
border-radius: 4px;
}
.k-input{color:black !important;
}
.footer{display:none}
.k-textbox>input, .k-autocomplete .k-input, .k-progress, .k-progress-status, .k-numeric-wrap.k-expand-padding .k-input, .k-multiselect-wrap{font-family: IRANSansWeb !important;
}
</style>
<script>
form = ALL_FORMS[0].Form.FormTemplate;
function RenderButton() {
var htmlButton = '<input type="button" ';
htmlButton += ' class="k-button sg-button" onclick="OpenUrl()" value="مشاهده درخواست"></input>'
return htmlButton;
}
function OpenUrl()
{
var SelectID = form.GetControl("dg_karbar").InputControl.GetSelectedItem().ID ;
var Name = form.GetControl("dg_karbar").InputControl.GetSelectedItem().Title ;
var options = {
title: "فرم درخواست رزرواسیون" +' '+Name,
width: 1500,
height: 600,
url: "/Lists/ReservRequest/EditForm.aspx?ID=" + SelectID };
SP.UI.ModalDialog.showModalDialog(options);
}
function RenderButtonAdmin() {
var htmlButton = '<input type="button" ';
htmlButton += ' class="k-button sg-button" onclick="OpenUrlAdmin()" value="مشاهده درخواست"></input>'
return htmlButton;
}
function OpenUrlAdmin()
{
var SelectID = form.GetControl("dg_karbarAdmin").InputControl.GetSelectedItem().ID ;
var Name = form.GetControl("dg_karbarAdmin").InputControl.GetSelectedItem().Title ;
var options = {
title: "فرم درخواست رزرواسیون" +' '+Name,
width: 1500,
height: 600,
url: "/Lists/ReservRequest/EditForm.aspx?ID=" + SelectID };
SP.UI.ModalDialog.showModalDialog(options);
}
$(function () {
$('[id*=btnExport]').on('click', function () {
ExportToExcel('dg_karbarAdmin_Grid');
// location.reload();
});
});
function ExportToExcel(Id) {
form = ALL_FORMS[0].Form.FormTemplate
var NumberForm = "کل درخواست های سفر";
debugger
var tab_text = "<table border='2px'><tr background-color='red'>شرکت ملی انفورماتیک ملی ایران شرکت ملی انفورماتیک ملی ایران</tr><tr>";
var textRange;
var j = 0;
tab = document.getElementById(Id);
var headerRow = $('[id*=dg_karbarAdmin_Grid] tr:first');
tab_text += headerRow.html() + '</tr><tr>';
var rows = $('[id*=dg_karbarAdmin_Grid] tr:not(:has(th))');
for (j = 0; j < rows.length; j++) {
if ($(rows[j]).css('display') != 'none') {
tab_text = tab_text + rows[j].innerHTML + "</tr>";
}
}
debugger
tab_text = tab_text + "</table>";
tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, ""); //remove if u want links in your table
tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table
tab_text = tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params
var ua = window.navigator.userAgent;
var msie = ua.indexOf("MSIE ");
if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer
{
txtArea1.document.open("txt/html", "replace");
txtArea1.document.write(tab_text);
txtArea1.document.close();
txtArea1.focus();
sa = txtArea1.document.execCommand("SaveAs", true, NumberForm +".xls");
}
else { //other browser not tested on IE 11
var a = document.createElement('a');
var data_type = 'data:application/vnd.ms-excel';
var table_div = tab_text; //Your tab_text
var table_html = table_div.replace(/ /g, '%20');
a.href = data_type + ', ' + table_html;
//setting the file name
a.download = NumberForm + "-" + '.xls';
//triggering the function
a.click();
}
return (sa);
}
$(function () {
$('[id*=btnExport]').on('click', function () {
ExportToExcelkarbar('dg_karbar_Grid');
// location.reload();
});
});
function ExportToExcelkarbar(Id) {
form = ALL_FORMS[0].Form.FormTemplate
var NumberForm = "کل درخواست های تسهیلات کاربر";
debugger
var tab_text = "<table border='2px'><tr background-color='red'>شرکت ملی انفورماتیک ملی ایران شرکت ملی انفورماتیک ملی ایران</tr><tr>";
var textRange;
var j = 0;
tab = document.getElementById(Id);
var headerRow = $('[id*=dg_karbar_Grid] tr:first');
tab_text += headerRow.html() + '</tr><tr>';
var rows = $('[id*=dg_karbar_Grid] tr:not(:has(th))');
for (j = 0; j < rows.length; j++) {
if ($(rows[j]).css('display') != 'none') {
tab_text = tab_text + rows[j].innerHTML + "</tr>";
}
}
debugger
tab_text = tab_text + "</table>";
tab_text = tab_text.replace(/<A[^>]*>|<\/A>/g, ""); //remove if u want links in your table
tab_text = tab_text.replace(/<img[^>]*>/gi, ""); // remove if u want images in your table
tab_text = tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params
var ua = window.navigator.userAgent;
var msie = ua.indexOf("MSIE ");
if (msie > 0 || !!navigator.userAgent.match(/Trident.*rv\:11\./)) // If Internet Explorer
{
txtArea1.document.open("txt/html", "replace");
txtArea1.document.write(tab_text);
txtArea1.document.close();
txtArea1.focus();
sa = txtArea1.document.execCommand("SaveAs", true, NumberForm +".xls");
}
else { //other browser not tested on IE 11
var a = document.createElement('a');
var data_type = 'data:application/vnd.ms-excel';
var table_div = tab_text; //Your tab_text
var table_html = table_div.replace(/ /g, '%20');
a.href = data_type + ', ' + table_html;
//setting the file name
a.download = NumberForm + "-" + '.xls';
//triggering the function
a.click();
}
return (sa);
}
form = ALL_FORMS[0].Form.FormTemplate;
function div(a, b) {
return parseInt((a / b));
}
function gregorian_to_jalali(g_y, g_m, g_d) {
var g_days_in_month = [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31];
var j_days_in_month = [31, 31, 31, 31, 31, 31, 30, 30, 30, 30, 30, 29];
var jalali = [];
var gy = g_y - 1600;
var gm = g_m - 1;
var gd = g_d - 1;
var g_day_no = 365 * gy + div(gy + 3, 4) - div(gy + 99, 100) + div(gy + 399, 400);
for (var i = 0; i < gm; ++i)
g_day_no += g_days_in_month[i];
if (gm > 1 && ((gy % 4 == 0 && gy % 100 != 0) || (gy % 400 == 0)))
/* leap and after Feb */
g_day_no++;
g_day_no += gd;
var j_day_no = g_day_no - 79;
var j_np = div(j_day_no, 12053);
/* 12053 = 365*33 + 32/4 */
j_day_no = j_day_no % 12053;
var jy = 979 + 33 * j_np + 4 * div(j_day_no, 1461);
/* 1461 = 365*4 + 4/4 */
j_day_no %= 1461;
if (j_day_no >= 366) {
jy += div(j_day_no - 1, 365);
j_day_no = (j_day_no - 1) % 365;
}
for (var i = 0; i < 11 && j_day_no >= j_days_in_month[i]; ++i)
j_day_no -= j_days_in_month[i];
var jm = i + 1;
var jd = j_day_no + 1;
jalali[0] = jy;
jalali[1] = jm;
jalali[2] = jd;
return jalali;
//return jalali[0] + "" + jalali[1] + "" + jalali[2];
//return jy + "/" + jm + "/" + jd;
}
</script>
//Created = form.DataItem.Created
//form.GetControl("c_Created").SetValue(Created);
ID = form.RequestValue("ParentItemID");
form.HideSection("ParentID");
form.GetControl("c_ParentID").SetValue(ID);
if (ID != ""){
form.ShowSection("ParentID");
form.HideTab(1);
form.HideTab(2);
}
if (form.RequestValue("IsDlg") == "1"){
form.HideTab(1);
form.ShowTab(0);
form.ShowSection("ParentID");
}
form.HideTab(2)
if (form.UserInGroup("252") == true){
form.ShowTab(2)
}
c_EndDate = form.GetControl("c_EndDate").GetValue()
c_Location = form.GetControl("c_Location").GetValue_Name()
c_StartDate = form.GetControl("c_StartDate").GetValue()
if (c_StartDate != "" && c_EndDate != "" && c_Location == "کیش"){
if (c_EndDate < c_StartDate){
alert("تاریخ شروع سفر نمی تواند بعد از تاریخ پایان سفر باشد.")
form.GetControl("c_StartDate").SetValue()
}
}
form = ALL_FORMS[0].Form.FormTemplate;
if (form.IsNewRecord()){
Title = form.GetControl("c_TitleUser").GetValue() ;
form.GetControl("lbl_UserName").SetValue(Title) ;
}
if (form.GetControl("c_Location").GetValue_Name() == "کیش"){
form.GetControl("lbl_Error").SetValue()
form.GetControl("c_Hotel").SetValue()
}
if (form.GetControl("c_Location").GetValue_Name() == "شمال"){
form.GetControl("lbl_Error").SetValue()
form.GetControl("c_Hotel").SetValue("اقامتگاه دریا")
}
c_Location = form.GetControl("c_Location").GetValue_Name()
c_EndDate = form.GetControl("c_EndDate").GetValue()
c_StartDate = form.GetControl("c_StartDate").GetValue()
if (c_StartDate != "" && c_EndDate != "" && c_Location == "کیش"){
if (c_EndDate < c_StartDate){
alert("تاریخ پایان سفر نمیتواند قبل از تاریخ شروع سفر باشد")
form.GetControl("c_EndDate").SetValue()
}
}
index = 0 ;
gridPhase = form.GetControl('dg_DetailsShomal').InputControl.GetAllItems();
for (var i=0; i < gridPhase.length; i++)
{
index += 1 ;
gridPhase[i].SetValue('Row' , index);
}
index = 0 ;
gridPhase = form.GetControl('dg_DetailsKish').InputControl.GetAllItems();
for (var i=0; i < gridPhase.length; i++)
{
index += 1 ;
gridPhase[i].SetValue('Row' , index);
}
c_EndDate = form.GetControl("dt_End").GetValue()
c_StartDate = form.GetControl("dt_Start").GetValue()
if (c_StartDate != "" && c_EndDate != ""){
if (c_EndDate < c_StartDate){
alert("بازه شروع زمانی نمیتواند از پایان بازه بیشتر باشد")
form.GetControl("dt_Start").SetValue()
}
}
c_EndDate = form.GetControl("dt_End").GetValue()
c_StartDate = form.GetControl("dt_Start").GetValue()
if (c_StartDate != "" && c_EndDate != ""){
if (c_EndDate < c_StartDate){
alert("پایان بازه زمانی نمیتواند کمتر از شروع بازه زمانی باشد")
form.GetControl("dt_End").SetValue()
}
}